﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MusicOnSpace
{
    public class Album
    {
        public string aId { get; set; }
        public string aName { get; set; }
        public string aPrice { get; set; }
        public string aRate { get; set; }
        public string aSinger { get; set; }

        List<Album> albumList = new List<Album>();
        dataProvider dp = new dataProvider();

        public void InsertAlbumber(string id, string name, string genre, string singname, string descript)
        {
            string command = "Insert into Album (aId, aName, aGenre, aCoverUrl, singName, Description) values (" + id + "," + name + "," + genre + "," + singname + "," + descript +")";

            dp.ExeCuteNonQuery(command);
        }

        public void DeleteAlbumber(string id)
        {
            string command = "";
            dp.ExeCuteNonQuery(command);
        }

        public void AlbumSearch(string name)
        {
            string command = "Select * from Album where name like 'N" + name + "'";
            dp.ExeCuteNonQuery(command);
        }

        public void GetAlbumber()
        {

        }

        public List<Album> AddAlbum()
        {
            //SqlCommand cmd = new SqlCommand ("Insert into Albumber (
            return albumList;
        }
        
    }
}